import pandas as pd
import numpy as np
import seaborn as sns

income = pd.read_excel(r'audlt_test.xlsx')
a = income.apply(lambda x:np.sum(x.isnull()))
print(a)
income.fillna(value = {'workclass':income.workclass.mode()[0],'occupation':income.occupation.mode()[0],'native-country':income['native-country'].mode()[0]}, inplace = True)
print(income.head())
print(income.describe())
print(income.describe(include =[ 'object']))